This model dimension represents sales promotion deal and is based on the IFS Applications dimension DIM_SALES_PROMOTION_DEAL. All models that refer to this dimension will have the attributes and hierarchies as described below.
| Attribute | Description (where applicable) |
| Sales Promotion Deal | Built as COMPAIGN_ID + ' - ' + CODE + ' - ' + DESCRIPTION |
| Sales Promotion Deal Campaign | The parent key, campain identity (CAMPAIN_IDENTITY) |
| Sales Promotion Deal Code | Represents the CODE of the dimension, i.e. the campain deal identity |
| Sales Promotion Deal Descr | Represents the DESCRIPTION of the campain deal |
| Model Name |
| Sales |
The data source for this object is defined using IFS Developer Tool. The data source contains a number of transformations where the model reads data from the last step, i.e. the Data source view name (DW Source View Name).
| Model Table | DW Source view (SQL Server) | BI Access View | Referenced Information Source | Recommended Access Type |
| SALES PROMOTION DEAL | DIM_SALES_PROMOTION_DEAL_BI | DIM_SALES_PROMOTION_DEAL_BI | DIM_SALES_PROMOTION_DEAL | On Line |